﻿-- =============================================
-- Author:		M.A
-- Create date: 05/11/2013
-- Description:	Gets the list of passenges
-- =============================================
CREATE PROCEDURE [trUser].[sp_Passengers_SELECT] 
	-- Add the parameters for the stored procedure here
	 --@CustomerDeviceId as Bigint
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
	-- get the passenger
	SELECT U.Name,U.Email,P.*, 
			U.DateCreated as User_DateCreated,
			U.DateInactive as User_DateInactive,
			U.DateUpdated as User_DateUpdated
	FROM trUser.tblPassengers P
		INNER JOIN trUser.tblUsers U on U.IDUser = P.IDUser
	
	
END

-- TEST HERE
	-- EXEC trUser.sp_Passengers_SELECT